--
-- NEW SQL FOR BESTDEAL 1.0
--

--
-- Tabel structuur voor tabel `ldu_bestdeal_bid`
--

DROP TABLE IF EXISTS `ldu_bestdeal_bid`;
CREATE TABLE `ldu_bestdeal_bid` (
  `bdbid_id` int(11) NOT NULL auto_increment,
  `bdbid_user` int(11) NOT NULL,
  `bdbid_mailpm` int(1) NOT NULL,
  `bdbid_item_id` int(11) NOT NULL,
  `bdbid_date` int(11) NOT NULL,
  `bdbid_bid` varchar(10) NOT NULL,
  `bdbid_state` int(2) NOT NULL,
  PRIMARY KEY  (`bdbid_id`),
  UNIQUE KEY `bdbid_user_2` (`bdbid_user`,`bdbid_item_id`,`bdbid_date`)
) TYPE=MyISAM ;

-- --------------------------------------------------------

--
-- Tabel structuur voor tabel `ldu_bestdeal_cat`
--

DROP TABLE IF EXISTS `ldu_bestdeal_cat`;
CREATE TABLE `ldu_bestdeal_cat` (
  `bdcat_id` int(11) NOT NULL auto_increment,
  `bdcat_headcat` int(11) NOT NULL,
  `bdcat_name` varchar(64) NOT NULL,
  `bdcat_shortdesc` text NOT NULL,
  `bdcat_level` int(2) NOT NULL,
  `bdcat_fmode` int(1) NOT NULL,
  `bdcat_timebeforereact` int(3) NOT NULL,
  PRIMARY KEY  (`bdcat_id`)
) TYPE=MyISAM ;

-- --------------------------------------------------------

--
-- Tabel structuur voor tabel `ldu_bestdeal_item`
--

DROP TABLE IF EXISTS `ldu_bestdeal_item`;
CREATE TABLE `ldu_bestdeal_item` (
  `bditem_id` int(11) NOT NULL auto_increment,
  `bditem_cat_id` int(11) NOT NULL,
  `bditem_user` int(11) NOT NULL,
  `bditem_name` varchar(64) NOT NULL,
  `bditem_shortdesc` varchar(64) NOT NULL,
  `bditem_state` int(2) NOT NULL,
  `bditem_editdate` int(11) NOT NULL,
  `bditem_adddate` int(11) NOT NULL,
  `bditem_state_enddate` int(11) NOT NULL,
  `bditem_startdate` int(11) NOT NULL,
  `bditem_price` varchar(10) NOT NULL,
  `bditem_mode` int(1) NOT NULL,
  `bditem_photo` text NOT NULL,
  `bditem_details` text NOT NULL,
  `bditem_hits` int(6) NOT NULL,
  `bditem_location` varchar(64) NOT NULL,
  `bditem_phone` int(15) NOT NULL,
  `bditem_mailpm` int(1) NOT NULL,
  PRIMARY KEY  (`bditem_id`)
) TYPE=MyISAM ;
